SET NOCOUNT ON
SET QUOTED_IDENTIFIER ON
GO

PRINT '---- tblPools'

PRINT '-- Table title'
INSERT tblUFGTableTitles (utt_Tablename, utt_Languagename, utt_Title, utt_Description)
VALUES ('tblPools','Nederlands','Poules','Poule gegevens')

PRINT '-- Column titles'
INSERT tblUFGColumnTitles
(uct_TableName,uct_ColumnName,uct_Languagename,uct_Title,uct_SubTitle)
VALUES
('tblPools','pol_Season','Nederlands','Seizoen','U dient een seizoen in te vullen.')

INSERT tblUFGColumnTitles
(uct_TableName,uct_ColumnName,uct_Languagename,uct_Title,uct_SubTitle)
VALUES
('tblPools','pol_TeamKind','Nederlands','Teamsoort','U dient een teamsoort in te vullen.')

INSERT tblUFGColumnTitles
(uct_TableName,uct_ColumnName,uct_Languagename,uct_Title,uct_SubTitle)
VALUES
('tblPools','pol_ClassName','Nederlands','Niveau','U dient een niveau in te vullen.')

INSERT tblUFGColumnTitles
(uct_TableName,uct_ColumnName,uct_Languagename,uct_Title,uct_SubTitle)
VALUES
('tblPools','pol_PoolName','Nederlands','District','U dient een district in te vullen.')

PRINT '-- Column titles'
PRINT '-- Panels'
PRINT '-- Display'

UPDATE tblUFGTables 
SET utb_DisplayInCategory = 'MAINTABLES' 
WHERE utb_TableName = 'tblpools' 